-
with result(class_id,parent_class_id,class_name) as ( select r.class_id,r.parent_class_id,r.class_name from class_master r where r.class_id=1 UNION ALL select p.class_id,p.parent_class_id,p.class_name from result c,class_master p where …
- 352 views
- 0 answers
- 0 votes
-
I have a MySQL table which is as follows: id | name | parent_id 19 | category1 | 0 20 …
- 842 views
- 15 answers
- 0 votes